<div>
	<p>How should the job handle updates to data over time?</p>

	<input type="radio" name="update_strategy" value="truncate"
		checked="checked" id="update_strategy_checkbox_truncate" /> <label class="blue"
		for="update_strategy_checkbox_truncate">Truncate target table</label>
	<div style="margin: 20px; margin-top: 4px;">
		<p>Using this option you truncate (delete all existing records)
			the target table every time, before inserting the records from the
			source table.</p>
	</div>

	<input type="radio" name="update_strategy" value="lookup_and_update"
		id="update_strategy_checkbox_lookup_and_update" /> <label class="blue"
		for="update_strategy_checkbox_lookup_and_update">Toggle insert
		and update based on primary key lookup</label>
	<div style="margin: 20px; margin-top: 4px;">
		<p>Use a primary key column to look up if a record already has
			been copied or not. If the record exists in the target already, issue
			an UPDATE instead of an INSERT.</p>
		<p>Primary key column: <select name="lookup_and_update_column_select">
			<#list columnNames as columnName>
				<option value="${columnName}">${columnName}</option>
			</#list>
		</select> </p>
	</div>

	<input type="radio" name="update_strategy" value="no_strategy"
		id="update_strategy_checkbox_no_strategy" /> <label class="blue"
		for="update_strategy_checkbox_no_strategy">No update strategy</label>
	<div style="margin: 20px; margin-top: 4px;">
		<p>Do not handle update logic in the job / handled elsewhere
			(running the job several times may cause duplicates).</p>
	</div>
</div>